
<h2 class='header'>Who's nominated Who</h2>
<div class='contentBody'>
	<p>This page is to list which panel judge has voted and for which blog.</p>
	<?php
		$db->Query("SELECT DISTINCT member.name, category.name, contestant.url FROM member, category, contestant, nomination, member_vote
									WHERE category.id = nomination.category_id AND contestant.id = nomination.contestant_id AND nomination.id = member_vote.nomination_id AND member_vote.member_id = member.id
									ORDER BY member.name, category.name, contestant.url");
		if($db->getRow()) {
			echo "<table border='1' cellspacing='0' cellpadding='5'>
							<tr>
								<th>Judge Name</th>
								<th>Category</th>
								<th>Blog URL Vote</th>
							</tr>";
			do {
				echo "<tr>
								<td>".$db->access[0]."</td>
								<td>".$db->access[1]."</td>
								<td>".$db->access[2]."</td>
							</tr>";
			} while($db->getRow());
			echo "</table>";
		}
	?>
	<br />
</div>